package cn.com.api.mapper.base;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiU_circle_member;

//DAO
public interface U_circle_memberMapperBase {

	// 根据id查看
	@Select("SELECT * FROM U_CIRCLE_MEMBER  WHERE ID = #{id}")
	public ApiU_circle_member findU_circle_memberById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM U_circle_member")
	public List<ApiU_circle_member> findU_circle_members();

	// 根据条件查看数据集
	public List<Map<String, Object>> findU_circle_membersByMap(HashMap condition);

	// 添加
	public int insertU_circle_member(ApiU_circle_member u_circle_member);

	// 修改
	@Update("UPDATE U_CIRCLE_MEMBER SET CIRCLE_ID = #{circle_id,jdbcType=VARCHAR}, USER_ID = #{user_id,jdbcType=VARCHAR}, ADD_TIME = #{add_time,jdbcType=VARCHAR}, APPLY_MSG = #{apply_msg,jdbcType=VARCHAR}, IS_DEAL = #{is_deal,jdbcType=INTEGER}, UPDATE_TIME = #{update_time,jdbcType=VARCHAR}, STATUS = #{status,jdbcType=INTEGER}, EXT1 = #{ext1,jdbcType=VARCHAR}, EXT2 = #{ext2,jdbcType=VARCHAR}, EXT3 = #{ext3,jdbcType=VARCHAR}, EXT4 = #{ext4,jdbcType=VARCHAR}, EXT5 = #{ext5,jdbcType=VARCHAR},is_admin = #{is_admin,jdbcType=INTEGER},nick_name = #{nick_name,jdbcType=VARCHAR},is_silent = #{is_silent,jdbcType=INTEGER},is_top = #{is_top,jdbcType=INTEGER},is_nointerrupt = #{is_nointerrupt,jdbcType=INTEGER},is_neglectnoread = #{is_neglectnoread,jdbcType=INTEGER},is_readdel = #{is_readdel,jdbcType=INTEGER} WHERE ID = #{id}")
	public int updateU_circle_member(ApiU_circle_member u_circle_member);

	// 删除
	@Delete("DELETE FROM U_CIRCLE_MEMBER  WHERE ID = #{id}")
	public int deleteU_circle_member(Integer id);

	// Foreign keys revelant

	// region Indexs revelant

}
